home *** CD-ROM | disk | FTP | other *** search
Wrap
Alarm HBAM2001MAY84 NLphoneCheck1.1N,'s :* 01114 104444444 12345 123456 174555555 788000 9789090 Ergens Alarm Nieuw Wordt Betaald Gratis Nieuw Id@ntL@belB TelNew#1B ,5), If(Left(TextToNum("0,."&TelOld)*10^7 ,5)="42576", Left(TextToNum("0,."&TelOld)*10^7 ,6), Left(TextToNum("0,."&TelOld)*10^6 ,4) )))) E: O/o 0! F!' Enkel Trick/Truc Lijst EnkelB Nieuw Euro nr gratis' Nieuw Euro nr betaald' Oud nr omgezet' Nieuw nr' Oud nr is nieuw nr' Enkel Trick/Truc Lijst EnkelB 42578 42579 42576 You cannot enter data into a calculationfield, but see below for a better trick. Je kan niet invoeren in een rekenveld, maar zie hieronder voor een betere truc. Trick/TrucB Trick/TrucB or (TextToNum("0,."&TelOld) < 1/100) , "OK: Internationaal", If(Left(@#1,1)=F 1 and (Length(1&TextToNum(TelOld)) - Length(TextToNum("0,."& Middle(TelOld,Position(TelOld & "; ","; ",1),32)&1)))=2 , "OK: Nieuw Euro nr", 30-12-1995 COMMENT N ID@NTL@BEL TELNEW#1 TELOLD TelOldB JJLcheckData JJLcheckData JJLcheckData JJLcheckData Nu test op lookup fout E: (0& ?? / ? d >>> F!(' 6880060 8788000 9789090 Afwijkende Comment Draaien Ergens Fantasienr Formattering Viavia Alarm 6266166 666666 8001234 Alarm Comment Nieuw Onzinnig Tst123 Viavia Wordt 06702431 14711164 14718666 16703021 2780300 3681740 3780100 3780200 Alarm Nieuw Omgezet Weinig Alarm Comment Nieuw Onzinnig Viavia Wordt Pro 2.0 - 2.1I Main Dictionary If(1 = 1 ,""," Nu test op lookup fout") & If(@#2 = 0 ,"Net+Abo bestaat niet of te kort nieuw nr", H If((Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, Position(TelOld&"; ", "; ", 1))&1)) Gaat ergens in 1996 inU 112; nieuw alarm nr._ OK: Nieuw Euro nr 0611; oud alarm nr; wordt 112F 6880060Q 61U (06) 11; oud alarm nr; wordt 112_ OK: 06 nr 8001234; 800 nrF 8788000Q (0800) 12 34; 800 nr_ OK: Nieuw Euro nr gratis 909 2212 34 56; nieuw koop nrF 9789090Q 909U!(0909) 22 12 34 56; nieuw koop nr_ OK: Nieuw Euro nr betaald 999; 123999; 123080 666666F 06702431Q (024) 366 66 66_ OK: Oud nr omgezet 030 22 22 2; tst 123F 16703021Q Fantasienr, niet draaien! 030 22 22 22; tst 123F 16703021Q Fantasienr, niet draaien!U (030) 222 22 22; tst 123_ OK: Oud nr omgezet 030 222 22 22; tst 123F 2780300Q Fantasienr, niet draaien!U (030) 222 22 22; tst 123_ OK: Nieuw nr 030 222 22 22 2; tst123F 2780300Q Fantasienr, niet draaien!U E: 1d >>>> F!_ 1 cijfer(s) te lang>>> F!>>> F!e langangjfer(s) te langsers YesfD E Comment N Id@ntL@bel Id@ntL@belB TelNew#1B If(Position(TelOld,"O",1) 1 and Position(TelOld,"O",1) < Position(TelOld & ";",";",1),"E: O/o 0! F!", If(Length(Int(TextToNum("0,."&TelOld&1)* B 10^(Length(TextToNum("0,."&Left(TelOld, Position(TelOld&"; ", "; ", 1))&1))-2))) < 3 , Middle(TelOld,Position(TelOld & "; ","; ",1)+2 ,99), If(Left(TextToNum(" 0,.&C Nieuw Omgezet Weinig Pro 1.0F! Pro 2.0 - 2.1I Main Dictionary 666666 8001234 Alarm Comment Nieuw Onzinnig Wordt 06702431 16703021 6880060 8788000 9789090 Draaien Ergens Fantasienr Alarm Pro 1.0F! Pro 2.0 - 2.1I Main Dictionary 1,."&TelOld)*1000 ,4) > 1090 and Left(TextToNum("1,."&TelOld)*1000 ,4) 1099 , "00"&Right(TelOld, Length(TelOld)-2), If((Position(TelOld,"+",1) 0 and TextToNum("0,."&TelOld) = D TextToNum("0,."&Right(TelOld, Length(TelOld)- Position(TelOld,"+",1)))) or (TextToNum("0,."&TelOld) < 1/100) or (Left(@#1,1)=1 and (Length(1&TextToNum(TelOld)) - Length(TextToNum("0,."&Middle(TelOld,Position(Te 950"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4951"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="8360"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="8851"or Left(TextToNum("0,."&TelOld)*10^7 ,5)="42572"or Left(TextToNumL ("0,."&TelOld)*10^7 ,5)="42575"or Left(TextToNum("0,."&TelOld)*10^7 ,5)="42577"or Left(TextToNum("0,."&TelOld)*10^7 ,5)="42578"or Left(TextToNum("0,."&TelOld)*10^7 ,5)="42579", Left(TextToNum("0,."&TelOld)*10^7 "or Left(TextToNum("0,."&TelOld)*10^6 ,4)="2990"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="3450"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="3480"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4132"or Left(TextToNum("0,J ."&TelOld)*10^6 ,4)="4160"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4167"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4180"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4927"or Left(TextToNum("0,."&TelOld)*10^6 ,4)="4 ",""), If(Left(@#2 ,1) 1 ,"Oud nr omgezet","")& If(Left(@#2 ,1) = 2 ,"Nieuw nr","")& IfR6(Left(@#2 ,1) = 3 ,"Oud nr is nieuw nr","")) ))))))))) E: Letter O/o cijfer 0! F!' Te weinig cijfer Now length check User Dictionary ' d <<<< F!' d >>>> F! )="6" or Left(TextToNum("0,."&TelOld)*10^6 ,1)="7", Left(TextToNum("0,."&TelOld)*10^6 , If(Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, H Position(TelOld&"; ", "; ", 1))&1))-3))) < 8 or Left(TextToNum("0,."&TelOld)*10^6 ,1)="6",2 ,3)), If(Left(TextToNum("0,."&TelOld)*10^6 ,4)="2907 TelOld)*10^6 ,2)="30"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="33"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="35"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="38"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="43"or Left(TF extToNum("0,."&TelOld)*10^6 ,2)="45"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="46"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="53"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="58"or Left(TextToNum("0,."&TelOld)*10^6 ,1 ), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@#2,1),1))),If(Left(@#2,1) = 6 ,2 ,4),9)) > 2 ," ","")& Middle(Middle(TextToNum(Middle(TelOld,Position(TelOld,Left(@#2,1),1), Position(TelOld&"; "R ,"; ",1) - Position(TelOld,Left(@#2,1),1))), If(Left(@#2,1) = 6 ,2 ,4),9),3 ,2) & If(Length(Middle(TextToNum(Middle(TelOld, Position(TelOld,Left(@#2,1),1), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@# 2,1),1))),If(Left(@#2,1) = 6 ,2 ,4),9)) > 4 , " ","")& Middle(Middle(TextToNum(Middle(TelOld,Position(TelOld,Left(@#2,1),1), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@#2,1),1))), If(Left(@#2,1) T = 6 ,2 ,4),9),5 ,2) & If(Length(Middle(TextToNum(Middle(TelOld, Position(TelOld,Left(@#2,1),1), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@#2,1),1))),If(Left(@#2,1) = 6 ,2 ,4),9)) > 6 , " ","")& Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ","; ",1)) &1)) - 3 ,1))&" "& Middle(TextToNum("0.,"&TelOld&1), Length(TextToNum("0,.Zr"&Left(TelOld,Position(TelOld&"; ","; ",1))& 1)) - 2 ,2))& Middle(TelOld,Position(TelOld&"; ","; ",1),32) )))))))) sition(TelOld & "; ","; ",1)+2 ,99), If(Left(TextToNum(" 0 ?? F!", "(0"&TextToNum(Middle(@#2 ,4 ,3))&") "& If(Left(@#2,1) > 4 , Left(Middle(TextToNum(MiddleP (TelOld, Position(TelOld,Left(@#2,1),1), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@#2,1),1))),If(Left(@#2,1) = 6 ,2 ,4),9),2) & If(Length(Middle(TextToNum(Middle(TelOld, Position(TelOld,Left(@#2,1),1 lOld & "; ","; ",1),32)&1)))=2), TelOld, If(1 = 1 ,""," Nu test op lookup fout") & If(@#2 = 0 ,"E: F (0"&Left(@#1, If(Length(@#1) < 4 ,2 ,3))&") "& Middle(@#1,If(Length(@#1) < 4 ,3 ,4),10)&"?? / ? d >>> F!", If((Length(Int(TextToNum("0,."&TelOld&1)* Middle(Middle(TextToNum(Middle(TelOld, Position(TelOld,Left(@#2,1),1), Position(TelOld&"; ","; ",1) - Position(TelOld,Left(@#2,1),1))), If(Left(@#2,1) = 6 ,2 ,4),9),7 ,2), V Middle(@#2,7 ,Right(@#2 ,1))& If(Middle(@#2 ,2 ,1) > 4 ,Middle(TextToNum("0.,"&TelOld&1), Le ngth(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ","; ",1)) &1)) - Middle(@#2 ,2 ,1), Middle(@#2 ,2 ,1)-4)&" ","")& If(Middle(@#2 ,2 ,1) > 3 ,Middle(TextToNum("0X .,"&TelOld&1), Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ","; ",1)) &1)) - 4 ,2), Middle(TextToNum("0.,"&TelOld&1), E: (0' ) 0 ??J F!(' Helvetica Monaco Chicago New Century Schlbk Geneva Courier Times Zapf Chancery No digits found Bestaat Betaald Cijfer Cijfers Gratis Letter 10^(Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ", "; ", 1))&1))-3))) = 8 and Left(@#2,1) = 1), "(0"& Middle (TextToNum("H 0,."&TelOld)*10^9 ,1 ,If(Length(@#1)=3 ,2 ,3)) & ") " & Middle (TextToNum("0,."&TelOld)*10^9 ,If(Length(@#1)=3 ,3 ,4),If(Length(@#1)=3 ,3 ,2)) & " " & Middle (TextToNum("0,."&TelOld)*10^9 ,6 ,2) & " " & Middle( 9991U E: (0999) 1?? / ? d >>> F!_(Net+Abo bestaat niet of te kort nieuw nr ; onzinnig commentU onzinnig comment_ Te weinig cijfers 080 666666F 06702431Q (024) 366 66 66_ OK: Oud nr omgezet 030 22 22 2; tst 123F 16703021Q Fantasienr, niet draaien!U E: 1d <<<< F!_ 1 cijfer(s) te kort (TextToNum("0,."&TelOld)*10^6 ,2)="50"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="55"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="70"or Left(TextToNum("0,."&TelOld)*10^6 ,2) ="80"or Left(TextToNum("0,."&TelOld)*10^6D ,2)="85"or Left(TextToNum("0,."&TelOld)*10^6 ,2) ="90", Left(TextToNum("0,."&TelOld)*10^6 ,3), If(Left(TextToNum("0,."&TelOld)*10^6 ,2)="15"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="23"or Left(TextToNum("0,."& If(Left(TextToNum("0,."&TelOld)*10^6 ,2)="10"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="13"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="20"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="24"or Left(TextToNum("0,."&TelOldB )*10^6 ,2)="26"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="36"or Left(TextToNum("0,."&TelOld)*10^6 ,2)="37"or (Left(TextToNum("0,."&TelOld)*10^6 ,2)="40" and Left(TextToNum("0,."&TelOld)*10^6 ,3) "406")or Left If(Middle(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&TelOld&1))-2)), (Middle(@#2 ,3 ,1)-Middle(@#2 ,2 ,1)+2),1) N = 0 and Left(@#2,1) < 5 , "E: (0"&Left(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&TelOld&1))-2)), Middle(@#2,3 ,1) - Middle(@#2,2 ,1) + 1)& ") E: (0& ?? / ? d >>> F!(' "E: " & Abs(Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ", "; ", 1))&1))-3))) - Middle(@#2 ,3 ,1))& If((Length(Int(TL extToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ", "; ", 1))&1))-3))) - Middle(@#2 ,3 ,1)) <0 , "d <<<< F!", "d >>>> F!"), TextToNum("0,."&TelOld)*10^10 ,8 ,2) & Middle(TelOld,Position(TelOld&"; ","; ",1),32), If(1=1 ,"","Now length check") &J If((Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld,Position(TelOld&"; ", "; ", 1))&1))-3))) Middle(@#2 ,3 ,1) and Left (@#2 ,1) < 5) , TelNew#1 E Comment N 112; nieuw alarm nr.F Left(@#2 ,1) < 5) and (Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, Position(TelOld&"; ", "; ", 1))&1))-3))) 8 or Left(@L #2,1) 1) , Abs(Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, 42572 42575 42577 A Comment NB If(Position(TelOld,"O",1) 1 and Position(TelOld,"O",1) < Position(TelOld & ";",";",1), "E: Letter O/o cijfer 0! F!", If(Length(Int(TextToNum(B "0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, Position(TelOld&"; ", "; ", 1))&1))-2))) < 3 , "Te weinig cijfers", 2212@ 6880060@ Gaat@ Nieuw@ 104444444; bgg 555 55 55F 3780100Q (010) 444 44 44; bgg 555 55 55_ OK: Oud nr is nieuw nr %A 174555555F 3681740Q 1745U (0174) 55 55 55_ OK: Oud nr is nieuw nr 020 6266166F 3780200Q ViaViaU (020) 626 61 66_ OK: Oud nr is nieuw nr ; (020) 626.616.6; = ViaViaF 3780200Q 206600Q 206 66 66 66F 14718666 3Q 1866U (0186) 66 66 66_ OK: Nieuw nr Gebruik Leggen Viavia 6266166 Alarm Comment Nieuw Onzinnig Viavia Wordt l {I0_*n L [i0 l {I0_*n A JJL/ShareB Users YesfD LijstB TelOld t niet of te kort nieuw nr' OK: Nieuw nr Now length check Te weinig cijfer Abo nr begint met een 0' OK: & 06 nr' Nieuw Euro nr gratis' Nieuw EI uro nr betaald' Oud nr omgezet' Nieuw nr' Oud nr is nieuw nr' Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&TelOld&1))-2)), (Middle(@#2 ,3 ,1)-Middle(@#2 ,2 ,1)+2),1) = 0 and Left(@#2,1) < 5 ,"Abo nr begint met een 0", "OK: P " & If(Left(@#2,1) > 4 ,If(Left (@#2 ,1) = 6 ,"06 nr","")& If(Left(@#2 ,1) = 8 ,"Nieuw Euro nr gratis","")& If(Left(@#2 ,1) = 9 ,"Nieuw Euro nr betaald Position(TelOld&"; ", "; ", 1))&1))-3))) - Middle(@#2 ,3 ,1))& " cijfer(s) te" & If(Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&LeftN (TelOld, Position(TelOld&"; ", "; ", 1))&1))-3))) - Middle(@#2 ,3 ,1) <0 , " kort", " lang"), If(Middle( -3))) = 8 and Left(@#2,1) = 1 ), "OK: Nieuw nr", If(1=1 ,"","Now length chJ eck") & If((Length(Int(TextToNum("0,."&TelOld&1)* 10^(Length(TextToNum("0,."&Left(TelOld, Position(TelOld&"; ", "; ", 1))&1))-3))) Middle(@#2 ,3 ,1) and EBThe trick: TelOld is transparent, and on top of/en boven op Telnew Oud intern. omgz.& OK: InC ternationaal& OK: Nieuw Euro nr Nu test op lookup fout '(Net+Abo bestaa cijfer(s) te(' ; ('G kort' lang 'S7Gebruik comment om afwijkende formattering op te leggenU (020) 626.616.6; = ViaVia_ Te weinig cijfers 186 66 66 66F 14718666 3Q 1866U (0186) 66 66 66_ OK: Nieuw nr 01114 12345F 14711164 3Q 1114U (0111) 41 23 45_ OK: Nieuw nr 09O9 123456F 9912U E: O/o 0! F!_ E: Letter O/o cijfer 0! F! TelOld TelNew#1 !!!!! Om geimporteerde of al bestaande gegevens om te zetten moet de cursor in TelOld gezet worden en Zoek opnieuw op uit het Wijzig Menu gedaan worden. !!!!!!! E Comment N Id@ntL@bel E Comment N Id@ntL@bel Dubbel veld, zowel invoer als resultaat. Druk op Tab om de invoer te zien, klik erbuiten voor het resultaat. Handig als je ruimte tekort komt. Double field, both input and result. Press Tab to see the input, CB)lick outside for the result. Saves space. You cannot enter data into a calculationfield, but see below for a better trick. Je kan niet invoeren in een rekenveld, maar zie hieronder voor een betere truc. You cannot enter data into a calculationfield, but see below for a better trick. Je kan niet invoeren in een rekenveld, maar zie hieronder voor een betere truc. If(Left(TextToNum("1,."&TelOld)*1000 ,4) > 1090 and Left(TextToNum("1,."&TelOld)*1000 ,4) 1099 ,"Oud intern. omgz.", If((PosD ition(TelOld,"+",1) 0 and TextToNum("0,."&TelOld) = TextToNum("0,."& Right(TelOld, Length(TelOld)- Position(TelOld,"+",1))))